Problem Note 36093: A stored process cannot read an XML Input Stream with an INFILE statement
A stored process cannot successfully read an XML Input Stream using an INFILE statement. Only the first 1024 characters of the XML Input Stream can be read successfully.
In the following example, only the first 1024 characters
of the XML Input Stream will be read:
data test;
infile webin; /* Read an XML Input Stream */
input;
list;
run;
In SAS® 9.1.3, the LRECL and RECFM options are not supported on an INFILE statement that reads an XML Input Stream. The default LRECL is 1024, so only 1024 character will be read.
The XML engine can successfully read an XML Input Stream. This is the proper approach to read an XML Input Stream. For example:
/* Use this approach */
libname webin xml;
proc copy in=webin out=work;
run;
An Input Stream can be specified using SAS® Management Console.
When running SAS Management Console in SAS 9.1.3, perform the following steps:
- Select the Properties window for the stored process.
- Select the Execution tab in the Properties window.
- Click the Streams button.
When running SAS Management Console in SAS® 9.2, perform the following steps:
- Select the Properties window for the stored process.
- Select the Data tab in the Properties window.
- Click the New button.
- Specify the Input Stream on the New Data Source window.
Operating System and Release Information
SAS System | SAS Integration Technologies | z/OS | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Linux | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Linux on Itanium | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
OpenVMS Alpha | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Solaris for x64 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Tru64 UNIX | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
A stored process cannot successfully read an XML Input Stream using an INFILE statement. Only the first 1024 characters of the XML Input Stream can be read successfully.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2009-07-17 14:51:28 |
Date Created: | 2009-05-29 12:34:02 |